<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head id="Head1" runat="server">
    <title>Linq Provider for Postgres</title>
    <link rel="stylesheet" type="text/css" href="../lib/style2.css"/>
</head>
<body>
    <form id="form1" runat="server">
<a href="../Default.aspx">&gt;Code2Code.net Home</a>  &nbsp; 
<a href="../Contact.html">&gt;Contacts</a> &nbsp; <a href="../doc/Credits.html">&gt;Credits</a> &nbsp; 
<a href="../doc/Links.html">&gt;Links</a> &nbsp; <a href="../doc/Other_Translators.html">&gt;Other Translation Engines</a>

        <h1>
            DbLinq Project: Linq Provider for PostgreSQL</h1>
    <div>
        <h3> Postgres-Specific Notes:</h3>
        1. Added basic support for PostgresSQL (version 8.2)<br />
        2. Added initial support for GROUP BY clauses.<br />
        2b.&nbsp; some 'GROUP BY' queries that will be accepted by Mysql will throw an
        exception in PostgreSQL:<br />
        &nbsp; &nbsp; <strong><span style="color: #0000cc">SELECT</span></strong> CustomerID,
        OrderID <strong><span style="color: #0000cc">FROM</span></strong> orders <strong><span
            style="color: #0000cc">GROUP BY</span></strong> CustomerID&nbsp;<br />
        &nbsp;&nbsp; &nbsp;<small>ERROR: column "orders.orderid" must appear in the GROUP BY clause
        or be used in an aggregate function
        <br />
        &nbsp;&nbsp; &nbsp; SQL state: 42803</small><br />
        <br />
        <br />
        <h3>
            Getting Started:</h3>
        1. Download general DbLinq required items, listed on the <a href="Default.aspx">main
            project page</a><br />
        2. Download Postgres 8.2&nbsp;<br />
        3. Download DbLinq.Postgres.zip<br />
        4. run PostgreSqlMetal.exe against your existing database to create a schema .cs
        file<br />
        5. Add the cs file and DbLinq.Postgres.Prototype.dll to your .NET project<br />
    </div>
    </form>
</body>
</html>
